Use the Database tab to set SQL/ODBC database options, the method you want to use to sort and display table and field names, and other advanced options.
When you select this check box, the program allows reporting on database tables in your SQL/ODBC data sources. This option is selected by default.
When you select this check box, the program allows reporting on virtual tables in your SQL/ODBC data sources. This option is selected by default.
When you select this check box, the program allows reporting on system tables. These tables are typically used by the system administrator only but are available for use if you have the appropriate permissions. This option is not selected by default.
When you select this check box, the program allows reporting on virtual tables that are available on some hosts. This option is not selected by default.
When you select this check box, the program will allow reporting on the result sets from stored procedures if you are using SQL systems that support stored procedures. This option is not selected by default.
This box allows you to enter the SQL LIKE function to specify the kinds of table names you want to appear in the Data Explorer. You can use the underscore character (_) and the percent sign character (%) as wildcards with this function. The underscore character specifies any single character, and while the percent sign signifies any character string. For example, DAV_ matches DAVE only, while DAV% matches both DAVE and DAVID. Table name Like C% would display only those tables that have a table name beginning with the letter C.
This box works exactly like the Table name Like box except that the LIKE function here is used to select the Owner (or Creator or Alias) of the table, not the table name itself. For example, Owner Like C% would display only those tables that have an owner beginning with the letter C.
When you select this check box, the program opens the Allow Reporting On dialog box before it opens the Data Explorer. The Allow Reporting On dialog box allows you to specify the types of data you want to appear in the Data Explorer. All of the options from the Show section of the Database tab appear in the Allow Reporting On dialog box.
By setting the options in this section of the Database tab, you can specify the text that you want the program to use for tables and fields.
When you select this check box, tables are displayed throughout the program sorted in alphabetical order (instead of the order they appear in the database). This option is selected by default.
When you select this check box, fields are displayed throughout the program sorted in alphabetical order (instead of the order they appear in the database table). This option is not selected by default.
Select this check box to use the available indexes/servers to speed the record selection process. If this check box is cleared, the record section process may be much slower. This option is selected by default.
Note: If an index has a name that is different from the database it indexes, you need to identify the index for the program. You do this using the Link Options dialog box, which you can access via the Visual Linking Expert.
Select this check box to have the program perform grouping on the server (server
Server
This option is not selected by default. See also the Report Options dialog box.
Select this check box to use the default alias for each database you activate. The default alias is the name of the database in one word without the extension. For example, the default alias for the database Craze.mdb is "craze." Use this option if you are usually satisfied with the default alias and do not want to have to accept or change the alias whenever you activate a database. This option is selected by default.
Clear this check box to display the Alias Name dialog box whenever you activate a database. You can accept the default alias or enter a new one in the Alias Name dialog box.
Note: The "accept" option does not prevent you from later changing the alias for any active database. If you want to change an alias, use the Set Alias command on the Database menu.
When this check box is selected, the program assumes that any character code it finds in a dBASE string field is an ASCII code and it translates that code to a corresponding ANSI value so that the same character that appears in dBASE appears in your report.
Note: If you clear this check box and you have used upper ASCII characters in your dBASE string fields, the special characters will not be the same in your report as they are in the dBASE string field.
This option is selected by default. See also the Report Options dialog box.
Select this check box if you want to search for strings in your SQL data without checking the case. For example, if your report contains SQL data and the data is of mixed case (red, RED, Red), a case
When this check box is selected, the program assumes that any character code it finds in a dBASE memo field is an ASCII code and it translates that code to a corresponding ANSI value so that the same character that appears in dBASE appears in your report.
Note: If you clear this check box and you have used upper ASCII characters in your dBASE memo fields, the special characters will not be the same in your report as they are in the dBASE memo field.
This option is selected by default. See also the Report Options dialog box.
Use this check box if you want the program to automatically link your tables when you are using the Visual Linking Expert. This option is selected by default.
Use this check box to produce all possible combinations of the original data. This option is not selected by default.
Note: The Cartesian Product option applies to OLAP data sources and does not apply specifically to other direct access data sources. The option ensures a report shows all values of all dimensions (as opposed to all values of the first dimension by one value of the second dimension, which would be the result if the option was not selected). See also the Report Options dialog box.
When this check box is selected, the program uses asynchronous queries. The program normally sends an entire query to the database server. Selecting this option, however, allows the program and the ODBC database server (if it supports asynchronous queries) to transfer data back and forth. An advantage of using this option is you can cancel queries during processing more easily. This option is not selected by default. See also the Report Options dialog box.
When Select Distinct Data for Browsing is selected, you can see the first 500 distinct (unique) records when you browse the contents of a database field.
When Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records.
Note: Note that since most SQL servers do not support selecting distinct records for long data types such as memo and blob fields, selecting and browsing distinct records are not supported for such fields.
See also the Report Options dialog box.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |